Some of the content in this topic may not be applicable to some languages.
If the add-in you want to use is not listed in the Add-Ins available box, click Browse, and then locate the add-in.
Note Excel may convert dates and times in the source range to values in the new currency in the destination range.
If your source range contains formulas, click Advanced, and select one of the conversion options under Formula options in the Advanced Euro Options dialog box.
You can also use this dialog box to control rounding.
Set either or both of the following options:
If you are converting between two euro member currencies and want to set the number of decimal places to use for rounding the intermediate values in euros, select the Set triangulation precision to check box, and then click the number of significant digits (3 or greater) you want in the digits box.
Currency To apply a currency format for the currency selected in the To list and copy the cell formatting, including borders and font, from the source cells.
ISO To display the International Standards Organization code for the converted currency and copy the cell formatting from the source cells. For a list of the ISO codes, see the EUROCONVERT worksheet function.
None To keep the current number format and cell formatting of the destination cells.
Click OK. If the Euro Conversion dialog box appears, select an option to convert the current formula. Click OK to move to the next formula, or click Apply to all to use the same settings for all formulas.
Notes